package com.example.sky20.util;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {
    private String FileName;
    private int DBType;
    private Connection conn;
    private String MysqlDriver;
    private String MysqlURL;

    public DBConnection() {
        conn = null;
    }
    public Connection getConn(){
        DBType = 1;
        switch (DBType){
            case 1:
                return(getConnToMysql());
            default:
                return null;
        }
    }

    private Connection getConnToMysql() {
        try {
            MysqlDriver = "com.mysql.cj.jdbcDriver";
            MysqlURL = "jdbc:mysql://localhost:3306/skycode"+
                    "user = root&password = 123456&"+
                    "userUnicode = true&characterEncoding = utf-8";
            Class.forName(MysqlDriver).newInstance();
            conn = DriverManager.getConnection(MysqlURL);
        }catch(Exception e){
        }
        return conn;
    }
}
